1.How do crimes spatially change in Philadelphia?
In this project, I loaded a “large” data sets of Philly: Crime Incidents (with over 1 million rows size) make animated maps of the data using datashader in Python and the data’s coordinates was transformed in Web Mercator (EPSG 3857).
Crime Incidents Change by Years(from 2006 to 2019)

2.What’s the pick-up & drop-off patterns of NYC taxis?
Based on the taxi data of New York City in 2015 (with 11,842,094 Rows size), I compared pick-up & drop-off points of how they change in the time of a day and determined where more pickups occur and where more dropoffs occur.
Time-lapse GIF of pick-ups over time

Time-lapse GIF of drop-offs over time

Comparing pickups and dropoffs
Turns out that pickups occur more often on major roads, and dropoffs on smaller roads.(Pixels with more pickups: red; Pixels with more dropoffs: blue)
